package com.ruoyi.test.excel;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.ruoyi.common.annotation.Excel;
import lombok.Data;

import java.io.Serializable;

public class ExcelDTO implements Serializable {
    /** 主键ID */
    @ExcelIgnore
    private Integer id;
    /**
     * 用名字去匹配，这里需要注意，如果名字重复，会导致只有一个字段读取到数据
     */
    @ExcelProperty("统一社会信用代码")
    @Excel(name = "统一社会信用代码")
    private String no;

    @ExcelProperty("名称")
    @Excel(name = "名称", readConverterExp = "0=正常,1=关闭")
    private String orgname;

    @ExcelProperty("资金数额(万元)")
    @Excel(name = "资金数额(万元)")
    private String money;

    @ExcelProperty("经营者")
    @Excel(name = "经营者")
    private String uname;

    @ExcelProperty("经营者证件号码")
    @Excel(name = "经营者证件号码")
    private String uid;

    @ExcelProperty("电话")
    @Excel(name = "电话")
    private String uphone;

    @ExcelProperty("营业额或营业收入")
    @Excel(name = "营业额或营业收入")
    private String vendInc ;

    @ExcelProperty("纳税总额")
    @Excel(name = "纳税总额")
    private String ratGro ;

    @ExcelProperty("备注")
    @Excel(name = "备注")
    private String aremark  ="";

    public String getVendInc() {
        return vendInc;
    }

    public void setVendInc(String vendInc) {
        this.vendInc = vendInc;
    }

    public String getRatGro() {
        return ratGro;
    }

    public void setRatGro(String ratGro) {
        this.ratGro = ratGro;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getNo() {
        return no;
    }

    public void setNo(String no) {
        this.no = no;
    }

    public String getOrgname() {
        return orgname;
    }

    public void setOrgname(String orgname) {
        this.orgname = orgname;
    }

    public String getMoney() {
        return money;
    }

    public void setMoney(String money) {
        this.money = money;
    }

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public String getUid() {
        return uid;
    }

    public void setUid(String uid) {
        this.uid = uid;
    }

    public String getUphone() {
        return uphone;
    }

    public void setUphone(String uphone) {
        this.uphone = uphone;
    }

    public String getAremark() {
        return aremark;
    }

    public void setAremark(String aremark) {
        if(aremark == null){
            aremark ="";
        }
        this.aremark = aremark;
    }
}
